package order;

import java.sql.*;
import java.io.*;
import java.util.*;

import common.db.*;
import common.main.*;

public class BasketListBean extends MainBean
{
	public void funcExecute() throws Exception
	{
		String id = (String)inputTable.get("id");
		
		queryBuffer = new StringBuffer("");
		queryBuffer.append("SELECT c.GNAME, c.GOODS_PRICE, c.SAVING_POINT, a.CODE, a.GOODS_CODE, a.SHOPPER_ID, a.PURCHARSE_VALUE, a.ORDER_STATE, a.PAYMENT_WAY, a.DELIVERY_METHOD, a.USE_YN, a.REG_ID, a.REG_DATE, a.REG_IP, a.UPD_ID, a.UPD_DATE, a.UPD_IP, b.IMG_PATH, b.OR_N  FROM ORDERLIST a, GOODS_IMG b, GOODS c WHERE a.GOODS_CODE=c.GCODE AND a.GOODS_CODE=b.GCODE_SEQ AND a.SHOPPER_ID='"+id+"' AND a.USE_YN='Y' AND a.ORDER_STATE=1 ORDER BY a.GOODS_CODE");

		DBExecute dbe = new DBExecute(queryBuffer.toString());
		outputList = dbe.getDataList();
	}
}